Microsoft Excel Q/a Practice Questions Answers Test With Solutions & More Shortcuts

Question : 11

In Excel numeric value can be treated as a label value if it precedes with

a) Apostrophe (‘)

b) Exclamation (!)

c) Hash (#)

d) Ampersand (&)

Question : 12

In Excel you can use the horizontal and vertical scroll bars to

a) Split a worksheet into two panes

b) View different rows and columns

c) Edit the contents of a cell

d) View different worksheets

Question : 13

Special category of Number tab in Format Cells dialog box can be used to apply formats like

a) Zip Code

b) Phone Number

c) Both of above

d) All of above

e) None of these

Question : 14

To copy cell contents using drag and drop, press the

a) End key

b) Shift key

c) Esc key

d) All the above

e) None of these

Question : 15

To centre a paragraph using shortcut keys, press __.

a) CTRL + C

b) CTRL + E

c) CTRL + L

d) CTRL + R

e) None of these